<?
require("config.php");

$location_status .= "| Delete";
$show_backnav = "subscription_menu";
$menuname = NULL;
$menutarget = NULL;

if (NULL!=$action){

	$Query = "DELETE FROM $table WHERE id=$id";
	myQuery($Query);

   header("location:" . $rela_path . "share/msg.php?v=51");

   exit();

}else{

  if (!checkRecord($table,$id)){

	header("location:" . $rela_path . "share/msg.php?v=9002");

	exit();
  
  }

}


$Query = "SELECT 
code,
email,
name,
company,
branch,
address,
zip,
city,
country,
messages,
date, 
last_name,
tel, 
mobile, 
profession, 
lang_english, 
lang_dannish, 
lang_chinese,
state
FROM $table WHERE id=$id LIMIT 1";

$r=myQuery($Query);

$Code=$r[0][0];
$Email=$r[0][1];
$Name=$r[0][2];
$Company=$r[0][3];
$Branch=$r[0][4];
$Address=$r[0][5];
$Zip=$r[0][6];
$City=$r[0][7];
$Country=$r[0][8];
$Messages=$r[0][9];
$Date=$r[0][10];
$last_name=$r[0][11];
$tel=$r[0][12];
$Mobile=$r[0][13];
$profession=$r[0][14];
$lang_english=$r[0][15];
$lang_dannish=$r[0][16];
$lang_chinese=$r[0][17];
$State=$r[0][18];
require($rela_path . "inc/header.php");

?>
<form action="" method="post" enctype="multipart/form-data" name="form1">
<input name="action" type="hidden" value="delete">
<input name="Email" type="hidden" value="<?print($Email)?>">





<table width="95%" border="0" align="center">
  <tr> 
      <td valign="top"> <p><br>
          <br>
          Are you sure to delete this Subscriber ? 
          <input type="submit" class="button" name="Submit2" value="  Yes  ">
          <input type="button" class="button" name="Submit3" value="  No  " onClick="Redirect('subscription_menu.php',1);">
          <br>
          <br>

<table>

        <tr> 
          <td class="tdheader">Code :</td>
          <td><?print($Code)?></td>
        </tr>

        <tr>
          <td class="tdheader">Subscription Date :</td>
          <td><?print($Date)?></td>
        </tr>
        <tr>
          <td class="tdheader">First Name :</td>
          <td><?=$Name?></td>
        </tr>
        <tr>
          <td class="tdheader">Last Name :</td>
          <td><?=$last_name?></td>
        </tr>
        <tr>
          <td class="tdheader">Subscriber's Email :</td>
          <td><?=$Email?></td>
        </tr>
        <tr>
          <td class="tdheader">Company</td>
          <td><?=$Company?></td>
        </tr>
        <tr>
          <td class="tdheader">Branch</td>
          <td><?=$Branch?></td>
        </tr>
        <tr>
          <td class="tdheader">Profession :</td>
          <td><?=$profession?></td>
        </tr>
        <tr>
          <td class="tdheader">Address:</td>
          <td><?=$Address?></td>
        </tr>
        <tr>
          <td class="tdheader">Zip</td>
          <td><?=$Zip?></td>
        </tr>
        <tr>
          <td class="tdheader">City</td>
          <td><?=$City?></td>
        </tr>
        <tr>
          <td class="tdheader">State</td>
          <td><?=$State?></td>
        </tr>
        <tr>
          <td class="tdheader">Country :</td>
          <td><?echo $Country?></td>
        </tr>
        <tr>
          <td class="tdheader">Tel :</td>
          <td><?=$tel?></td>
        </tr>
        <tr>
          <td class="tdheader">Mobile :</td>
          <td><?=$Mobile?></td>
          </tr>
          <tr>
            <td class="tdheader">Language :</td>
            <td>
              <input  disabled="disabled" name="lang_english" type="checkbox" id="lang_english" value="checked" <?print($lang_english)?> />
              English <br />
              <input  disabled="disabled" name="lang_dannish" type="checkbox" id="lang_dannish" value="checked" <?print($lang_dannish)?> />
              Danish <br />
              <input  disabled="disabled" name="lang_chinese" type="checkbox" id="lang_chinese" value="checked" <?print($lang_chinese)?> />
              Chinese </td>
          </tr>
        </table>
        <p><br>
      </td>

  </tr>
</table>
<br>
<br>
<br>

</form>

<?
require($rela_path . "inc/footer.php");
?>
